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