UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pFUAhRUwWlIfBKCjkkffTTkR1vTPvgAyl3/1jQ7EcLs='
WHERE
key_id = '58732a148c4822744fd64e3cd274a910df64482cb58c77ce033796103411ec9d'
AND (
token = 'pFUAhRUwWlIfBKCjkkffTTkR1vTPvgAyl3/1jQ7EcLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)