UPDATE 
  tmall_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0MfN+2jOmTrH1XJU0+BoJlfhY43/N8F3ooVAzy+i6vM=' 
WHERE 
  key_id = '19ea4d0df35c8c4df3c47a1256b188a0d9625b662f6f3336865d881ba05d3700' 
  AND (
    token = '0MfN+2jOmTrH1XJU0+BoJlfhY43/N8F3ooVAzy+i6vM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00777