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