UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oNjgbP8jVSCAD+adEz8Wdj7ffG/K6s5lV2fl5+Of2FU=' 
WHERE 
  key_id = '36d371a4259313e79d678ab53c460da5b1595d5def05edd5bd6a64e2c7e9c133' 
  AND (
    token = 'oNjgbP8jVSCAD+adEz8Wdj7ffG/K6s5lV2fl5+Of2FU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040