UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vR5k25XxIuJ/Km2M5E8vpmKRSH/7wW7k5nNJ7H97Rbs=' 
WHERE 
  key_id = 'ef4b2b61f6d353688aff12cfca762e040985eb9d539e192afd3dcd986d39631d' 
  AND (
    token = 'vR5k25XxIuJ/Km2M5E8vpmKRSH/7wW7k5nNJ7H97Rbs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028