UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mrndzG9xfc8ILs+PQRK2sjH5nW5L10DA8gfIPtzkQRs='
WHERE
key_id = 'f733e44a6707864854b1dd4582c4569e87bd081d78e611ffe947ccd78a218ac9'
AND (
token = 'mrndzG9xfc8ILs+PQRK2sjH5nW5L10DA8gfIPtzkQRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)