UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9TqtStCIeaqqk6gjuY40Z2i7NW/tSr6C345j2yhVH9U='
WHERE
key_id = '508e6b6a6ef9dbc776eea3a2edff87fdc3fe6375e0e8605d37602a9e3077b796'
AND (
token = '9TqtStCIeaqqk6gjuY40Z2i7NW/tSr6C345j2yhVH9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)