UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NYgz9OknczYLHXcDCVFkeflEmpDVfniyroE2JjEN3+U='
WHERE
key_id = 'd8aa9b2f2a99104f98ed8e0dfa7311aba3ee4b22b579c7636bcc661661348df1'
AND (
token = 'NYgz9OknczYLHXcDCVFkeflEmpDVfniyroE2JjEN3+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)