UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WgP3FRlCIwLj7Ef6ZuZTwnwSqbLdYWGKTfhcub2/Sto='
WHERE
key_id = 'b2a59402690964f81a186f727acdf21cae26a65902f0b6d46a2bb38618801ee1'
AND (
token = 'WgP3FRlCIwLj7Ef6ZuZTwnwSqbLdYWGKTfhcub2/Sto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)