UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HIpwNz9k3Ph3qiMaJ5ube7l0pkYVBUt4T5RlJX6p4qM='
WHERE
key_id = '9b3fa6d26f8d9535a4e76f7d2d82a2023177bba7cd2c9e325482ace74fc917bb'
AND (
token = 'HIpwNz9k3Ph3qiMaJ5ube7l0pkYVBUt4T5RlJX6p4qM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)