UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iU8vvzXDTqXGVkGhirKd1hNAtRh8/qjwqES6U7X/QBQ='
WHERE
key_id = '75c78579a790fa183f46daf311db39ba02dec2af627cdabc55aeee118738b64e'
AND (
token = 'iU8vvzXDTqXGVkGhirKd1hNAtRh8/qjwqES6U7X/QBQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)