UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IN8e4Sk2qqy3QkLJxzETGBZnU8XX/MzXGtE6+C88zsE='
WHERE
key_id = 'c4afb474c2a675c1cc181be6490d6f9da8f50ebe1149227b915dd6397d59ec44'
AND (
token = 'IN8e4Sk2qqy3QkLJxzETGBZnU8XX/MzXGtE6+C88zsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)