UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U7Cag6SLPzxsUlW7gxuNNV6ZscRM46u5h3klmMwZATA='
WHERE
key_id = '343e13a262c98ccd447b1c5e67e749834ef8e73f0c28a85bc681eefb0ae7641e'
AND (
token = 'U7Cag6SLPzxsUlW7gxuNNV6ZscRM46u5h3klmMwZATA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)