UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XscyCR571nWd1V2JevlG7tvJa1ZcwaVkhjgC/5VElWw='
WHERE
key_id = '812a399b45f2244a2357398ca090d870c3963d6594773a32445300c1dc0c5264'
AND (
token = 'XscyCR571nWd1V2JevlG7tvJa1ZcwaVkhjgC/5VElWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)