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