UPDATE 
  tmall_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Cfh0+2W0jOApjZcz17BB0k32y1kq78dl7Vd4mkzaS74=' 
WHERE 
  key_id = '5da8dccb6cff3abd3cd9238f7a1c63d1ab3523396e72d772e4d3ee0e919c0ce2' 
  AND (
    token = 'Cfh0+2W0jOApjZcz17BB0k32y1kq78dl7Vd4mkzaS74=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00813