UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U4pzH60uiGpyDcOB1yYNjSiBGRxCUE6f2fiuX2FSp5U='
WHERE
key_id = '8774b19353c5006e8a367b5ccffcc9922e9a15bad9f6fc295502fca6c01a1b21'
AND (
token = 'U4pzH60uiGpyDcOB1yYNjSiBGRxCUE6f2fiuX2FSp5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)