UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'C2Fx7O2d5q8Vu+wF/inV86IUrdLgMDqTPMZeknMRxfo=' 
WHERE 
  key_id = '895b2043c4ce8856e85a134aa15d0903fe6f9e2b77bbe89adb0d5871b0e9a0a6' 
  AND (
    token = 'C2Fx7O2d5q8Vu+wF/inV86IUrdLgMDqTPMZeknMRxfo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045