UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zypLN4EORkPXPhVZ6YOL7Qeig7R86oPY20FIQtY5Z9w='
WHERE
key_id = '4bc0613d387231ece009d4f7139273b8a79e02482f30ee81527134252fba5750'
AND (
token = 'zypLN4EORkPXPhVZ6YOL7Qeig7R86oPY20FIQtY5Z9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)