UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vwN7OwJIDKscOyj242cwxlmKsoxLG9eelMmPSGlklbU='
WHERE
key_id = '9cbed06bbe4384657a74a80fdc31482ae5b5b32444c9b64ec70203cca29f9245'
AND (
token = 'vwN7OwJIDKscOyj242cwxlmKsoxLG9eelMmPSGlklbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)