UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7eY8H0YSsY8YPYc5DUFXqrMB3BqdrVTyNEImJgWKsl0='
WHERE
key_id = '4ced5605d8559fdcac797da239a538b2a11ad9b9468a9eaa35a919be5dc0ef18'
AND (
token = '7eY8H0YSsY8YPYc5DUFXqrMB3BqdrVTyNEImJgWKsl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)