UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0opPvLU0CG0dKnBjwrETUW08jFSAVRpJcsIjIe1h+vA='
WHERE
key_id = '13ad0810b7daae13ec2494572e539def0c1c7c29ce8d377671a851ee7faa171f'
AND (
token = '0opPvLU0CG0dKnBjwrETUW08jFSAVRpJcsIjIe1h+vA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)