UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k9Ttj1kiwE1Z9omj6VvrVPJWgdDBESN/zHgSAWpZibo='
WHERE
key_id = '3c2e44f4aabd534d01078ca09a40f90f032bfb82b2ee96c22860e6ae5d1bb2e2'
AND (
token = 'k9Ttj1kiwE1Z9omj6VvrVPJWgdDBESN/zHgSAWpZibo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)