UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EcJcM1ZGS5pGp6/neNsknn9A7Zp6RN1F4w8aXwifRto=' 
WHERE 
  key_id = 'a875b5e4bab4a908ae064bac66982065fa6b92d83b10599f2acba69e2cdc95e7' 
  AND (
    token = 'EcJcM1ZGS5pGp6/neNsknn9A7Zp6RN1F4w8aXwifRto=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032