UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TL7/7akJ9tGFyfGszr5eV1QxAb31Iy+srdv1pXxyxdY='
WHERE
key_id = 'bab87595ac707891941f960206406682e9de2d48f0bd6669da4eb6a20ba3da42'
AND (
token = 'TL7/7akJ9tGFyfGszr5eV1QxAb31Iy+srdv1pXxyxdY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)