UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'abUDHeBFQhKsCHFZJ8NxeQig7zSeanBUCMBbVmWMwxE='
WHERE
key_id = '45329ddd1f7a57b3ca5387dd32baf1e52d9898a534a9984a9b52b2d45ba838bb'
AND (
token = 'abUDHeBFQhKsCHFZJ8NxeQig7zSeanBUCMBbVmWMwxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)