UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gv820YVkkshIPkX4AepLo4tDwd2Xztz44vgHdyEA+9U='
WHERE
key_id = 'fc77f7daa4d694eb6ab0d9e967fab4d6213c131eef6879f5e51b95223b1cab58'
AND (
token = 'Gv820YVkkshIPkX4AepLo4tDwd2Xztz44vgHdyEA+9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)