UPDATE 
  tmall_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+ZSAWOoTJfsNa+Wc72r3+pcNYGPq4G0/qjbKv6jJxvo=' 
WHERE 
  key_id = 'fc765d11e85d83d3feb3af48a2cfa1ec3313ad305ac0a0cc92b2a83142a7380f' 
  AND (
    token = '+ZSAWOoTJfsNa+Wc72r3+pcNYGPq4G0/qjbKv6jJxvo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00757