UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y4ZLpyJdqBfTeQXz+CDl85zorkuC6pTzkQbb9e+FOqM='
WHERE
key_id = 'e9fadb7864fda97a0dd0b77f5ffc4301eae2261ac994cea1c65fbbde6890cb9f'
AND (
token = 'y4ZLpyJdqBfTeQXz+CDl85zorkuC6pTzkQbb9e+FOqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)