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