UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/LUq2Ew2hR9ZRmYygfBJuk6MscUx8/0Qi/YHk56C+q0=' 
WHERE 
  key_id = 'f31f263fde9a421cc70b92b1e694d915c7f936984c189e4a078d3318762e756a' 
  AND (
    token = '/LUq2Ew2hR9ZRmYygfBJuk6MscUx8/0Qi/YHk56C+q0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028