UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+cag22WNagnFSTRorUGIGteAKVIiXZvcFc93z0TCy4w=' 
WHERE 
  key_id = 'd2625a0a27c8daa8554b16961e29f6f2f607ff7c0b26fa069eeb42eb52d39ce3' 
  AND (
    token = '+cag22WNagnFSTRorUGIGteAKVIiXZvcFc93z0TCy4w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044