UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0CZ9OEYtw8H4rF0M4YKC4P54dMeBqbuhirfSb/8cxUk='
WHERE
key_id = '9fc9537a4408558b111482664e1be6f7c7d429e09e881977daf708857ddd11b3'
AND (
token = '0CZ9OEYtw8H4rF0M4YKC4P54dMeBqbuhirfSb/8cxUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)