UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UMGsOW4MQ87yhIfjQjsPdEvxQ6p1KMeGkTLLUIxLvIg='
WHERE
key_id = 'b19b36014dd9f990f9dc326a3b4164f9ac95946ee9260664b3741111a8526b55'
AND (
token = 'UMGsOW4MQ87yhIfjQjsPdEvxQ6p1KMeGkTLLUIxLvIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)