UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q9LY2TQaF8hvtkQNvfid8EAlLWsZgmLDEpCgaZZtOjQ='
WHERE
key_id = 'e1f9601fe7eeff862c0b3ba2808741f216ccea707c4cf63fc033eb5defd19208'
AND (
token = 'q9LY2TQaF8hvtkQNvfid8EAlLWsZgmLDEpCgaZZtOjQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)