UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/P84/jTlZJ7xBq4PKkZH6DvyttvajpDi2kzT1bjH/r4='
WHERE
key_id = 'd1d432ee28c44e0c5c2fdf06290dd0442d50624b836495307af1e9555c1ee239'
AND (
token = '/P84/jTlZJ7xBq4PKkZH6DvyttvajpDi2kzT1bjH/r4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)