UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fNBGddlg9h8iFy1aiqq/3tNVYZI+J8+ztzgt+FTGp40='
WHERE
key_id = 'eeb7337d019111335cb913842b70f28c51a4b04406babd4da59956e0a4ad1716'
AND (
token = 'fNBGddlg9h8iFy1aiqq/3tNVYZI+J8+ztzgt+FTGp40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)