UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CanJ/aqLgaMFukfPlM0Np0etZ0gOXp+68OlIeGUigNk='
WHERE
key_id = 'c47fed02c71f4e4ba9743c0a2dcff7c95a3a7153444e4c3f1ba7a52ca0762fa3'
AND (
token = 'CanJ/aqLgaMFukfPlM0Np0etZ0gOXp+68OlIeGUigNk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)