UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ikAEZ/KTGrE+HwMazHjoTJBvIE0vZ0y8g5EvRMm24M='
WHERE
key_id = '0634093756302dbe634d8f0df491f8e7e1a3a4f68012979a1c2474082898f476'
AND (
token = '8ikAEZ/KTGrE+HwMazHjoTJBvIE0vZ0y8g5EvRMm24M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)