UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5NNOh4mGXE4qcFIiAF935Q3/oVXJGituvKsJymvFPsY='
WHERE
key_id = '8bcafe35dd42ee6fd41aaff750bfa9fc9aa77c8bdb5bf362766a55b7b3aba940'
AND (
token = '5NNOh4mGXE4qcFIiAF935Q3/oVXJGituvKsJymvFPsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)