UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hLHvW61Sw80Qu1qZtawXsZTiMue9Kg2SMv0D0l74RVQ=' 
WHERE 
  key_id = 'f8126b111f57b029792d5ce8657ce76f0f3e54f04be58da0094f02143f12a36b' 
  AND (
    token = 'hLHvW61Sw80Qu1qZtawXsZTiMue9Kg2SMv0D0l74RVQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026