UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XiNGZe7FHjgQD3ywrStIRwF/4/ln/9ULPSdDHYW+Jwc='
WHERE
key_id = 'b75352819c8c20b34d70bf56ab4ebb0984ac286825e08d2364591381f9a92a3b'
AND (
token = 'XiNGZe7FHjgQD3ywrStIRwF/4/ln/9ULPSdDHYW+Jwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)