UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZgW+Og/03qncbdK0LH15hj8P9KhtWNN5LPDe/jBFbMw='
WHERE
key_id = 'c37b86dae1e34c6e3a9e73b0e00a61c09e970aca1a82866ce38d69bc6c258183'
AND (
token = 'ZgW+Og/03qncbdK0LH15hj8P9KhtWNN5LPDe/jBFbMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)