UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Zkhwi2q0AWmZlnBfKGzfaFvU6tgcOOrd5CQ/nX9vKOc=' 
WHERE 
  key_id = 'a2349860fc372184005e8ed87b0ec99d1b2818275828c9346d0754f64f44c58b' 
  AND (
    token = 'Zkhwi2q0AWmZlnBfKGzfaFvU6tgcOOrd5CQ/nX9vKOc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033