UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H86sHUHIXYPHVqdF4ww3KOkGRNNfZCDhV2JqdZpBp6w='
WHERE
key_id = 'a5a795337164c5d71d63fd2d54ae06a32a9975d4e389ce20bbea13072f407968'
AND (
token = 'H86sHUHIXYPHVqdF4ww3KOkGRNNfZCDhV2JqdZpBp6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)