UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DGCZy62rCJUB/Qm2OB4+etlWvbJJfitW+Chxotcei58=' 
WHERE 
  key_id = 'ea0e276089fe284dc4667e7b4fb39f3573845c453ac542366841841b251b7e2b' 
  AND (
    token = 'DGCZy62rCJUB/Qm2OB4+etlWvbJJfitW+Chxotcei58=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033